<?php
require_once ('dbconfig.php');
require_once ('igb.php');
IGBRequireTrust ();
?>

<html>
<head>
<title>Corporate Ore Payout Prices</title>
</head>
<body>
<?php

$dbh = mysql_connect ( DB_HOST, DB_USER, DB_PASS ) or die ( mysql_error () );
mysql_select_db ( DB_NAME );
echo "<h1>Corp Ore Payout Prices Page</h1> <br>";
$sql = "select * from OrePurchasePrice order by oreSeq";
$result = mysql_query ( $sql, $dbh ) or die ( mysql_error () );

echo "<table cellpadding=1 cellspacing=1 border=1>";
echo "<tr><td><b>Ore</b></td><td align=\"right\"><b>Price</b></td></tr>";

while ( $newArray = mysql_fetch_array ( $result ) ) {
	$oreName = $newArray ['oreName'];
	$orePrice = $newArray ['orePrice'];
	$oreName2 = trim($oreName);
	echo "<tr><td width=125 align=\"left\">$oreName2</td><td align=\"right\">$orePrice</td></tr>";
} //end of while loop
echo "</table>";

?>

</body>
</html>